package com.wisemoresystem.seal.service;

import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Service;

import com.wisemoresystem.seal.base.service.BaseService;
import com.wisemoresystem.seal.model.t_mac_config;
@Service
public class MacConfigService extends BaseService {
	
	public t_mac_config selectMacConfig(String mac_id){
		String hql ="from t_mac_config t where t.mac_id=? and t.status=0";
		
		t_mac_config macConfig= super.findObj(hql, mac_id);
		return macConfig;
	}
	
	public List<Map<String, Object>> selectMac(){
		String sql = "select * from t_mac t where t.status=0 order by t.created asc ";
		List<Map<String, Object>> list = jt.queryForList(sql);
		return list;
	}
	
	public List<Map<String,Object>>  selectMacConfigList(String paper_id){
		String sql="select t.* from t_mac_config t where t.paper_id=? and t.status=0";
		
		List<Map<String,Object>> list = super.jt.queryForList(sql,paper_id);
		
		return list;
		
	}

	
}
